Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$BACKUP_CONTROLFILE_DETAILS

`V$BACKUP_CONTROLFILE_DETAILS` contains information about restorable control files. It will include all the control files backed up in the backup set, image copies, and proxy copies.

Column | Datatype | Description
--- | --- | ---
`BTYPE` | `CHAR(9)` | Backup type container. Possible values are `BACKUPSET`, `IMAGECOPY`, `PROXYCOPY`.
`BTYPE_KEY` | `NUMBER` | Unique identifier for the backup type, either `BS_KEY` or `COPY_KEY`.
`SESSION_KEY` | `NUMBER` | Session identifier
`SESSION_RECID` | `NUMBER` | Session recid
`SESSION_STAMP` | `NUMBER` | Session stamp
`ID1` | `NUMBER` | If `BACKUPSET`, it contains `SET_STAMP` If `IMAGECOPY` or `PROXYCOPY`, it is `RECID` from the control file
`ID2` | `NUMBER` | If `BACKUPSET`, it contains `SET_COUNT` If `IMAGECOPY` or `PROXYCOPY`, it is `STAMP`
`CREATION_TIME` | `DATE` | File creation time
`RESETLOGS_CHANGE#` | `NUMBER` | Resetlogs change SCN
`RESETLOGS_TIME` | `DATE` | Resetlogs change time
`CHECKPOINT_CHANGE#` | `NUMBER` | Checkpoint change SCN
`CHECKPOINT_TIME` | `DATE` | Checkpoint change time
`FILESIZE` | `NUMBER` | File size, in bytes, for the output of backing up this control file
`COMPRESSION_RATIO` | `NUMBER` | Compression ratio for this backup
`FILESIZE_DISPLAY` | `VARCHAR2(4000)` | Same value as the `FILESIZE` column, but converted to a user-displayable format, for example `n`M, `n`G, `n`T, `n`P, and so on